Node / ReticulumProjects / MeshChatX.git / files / tests / backend / test_database.py

Displaying Raw • Download

T8b949e# SPDX-License-Identifier: 0BSD

Tff7b72import T7ee787os

Tff7b72import T7ee787tempfile

Tff7b72import T7ee787pytest

Tff7b72from T7ee787meshchatxT7ee787.T7ee787srcT7ee787.T7ee787backendT7ee787.T7ee787database Tff7b72import Te6edf3Database

Tff7b72from T7ee787meshchatxT7ee787.T7ee787srcT7ee787.T7ee787backendT7ee787.T7ee787databaseT7ee787.T7ee787provider Tff7b72import Te6edf3DatabaseProvider

Tff7b72from T7ee787meshchatxT7ee787.T7ee787srcT7ee787.T7ee787backendT7ee787.T7ee787databaseT7ee787.T7ee787schema Tff7b72import Te6edf3DatabaseSchema

Tf0883e@pytestTff7b72.Td2a8fffixture

Tff7b72def Td2a8fftemp_dbTb4b4b4(Tb4b4b4)Tb4b4b4:

Te6edf3fdTb4b4b4, Te6edf3path Tff7b72= Te6edf3tempfileTff7b72.Td2a8ffmkstempTb4b4b4(Tb4b4b4)

Te6edf3osTff7b72.Td2a8ffcloseTb4b4b4(Te6edf3fdTb4b4b4)

Tff7b72yield Te6edf3path

Tff7b72if Te6edf3osTff7b72.Td2a8ffpathTff7b72.Td2a8ffexistsTb4b4b4(Te6edf3pathTb4b4b4)Tb4b4b4:

Te6edf3osTff7b72.Td2a8ffremoveTb4b4b4(Te6edf3pathTb4b4b4)

Tff7b72def Td2a8fftest_database_initializationTb4b4b4(Te6edf3temp_dbTb4b4b4)Tb4b4b4:

Te6edf3provider Tff7b72= Te6edf3DatabaseProviderTb4b4b4(Te6edf3temp_dbTb4b4b4)

Te6edf3schema Tff7b72= Te6edf3DatabaseSchemaTb4b4b4(Te6edf3providerTb4b4b4)

Te6edf3schemaTff7b72.Td2a8ffinitializeTb4b4b4(Tb4b4b4)

T8b949e# Check if tables were created

Te6edf3tables Tff7b72= Te6edf3providerTff7b72.Td2a8fffetchallTb4b4b4(Ta5d6ff"Ta5d6ffSELECT name FROM sqlite_master WHERE type=Ta5d6ff'Ta5d6fftableTa5d6ff'Ta5d6ff"Tb4b4b4)

Te6edf3table_names Tff7b72= Tb4b4b4[Te6edf3rowTb4b4b4[Ta5d6ff"Ta5d6ffnameTa5d6ff"Tb4b4b4] Tff7b72for Te6edf3row Tff7b72in Te6edf3tablesTb4b4b4]

Tff7b72assert Ta5d6ff"Ta5d6ffconfigTa5d6ff" Tff7b72in Te6edf3table_names

Tff7b72assert Ta5d6ff"Ta5d6fflxmf_messagesTa5d6ff" Tff7b72in Te6edf3table_names

Tff7b72assert Ta5d6ff"Ta5d6ffannouncesTa5d6ff" Tff7b72in Te6edf3table_names

T8b949e# Check version

Te6edf3version_row Tff7b72= Te6edf3providerTff7b72.Td2a8fffetchoneTb4b4b4(

Ta5d6ff"Ta5d6ffSELECT value FROM config WHERE key = Ta5d6ff'Ta5d6ffdatabase_versionTa5d6ff'Ta5d6ff"Tb4b4b4,

Tb4b4b4)

Tff7b72assert Tffa657intTb4b4b4(Te6edf3version_rowTb4b4b4[Ta5d6ff"Ta5d6ffvalueTa5d6ff"Tb4b4b4]Tb4b4b4) Tff7b72== Te6edf3DatabaseSchemaTff7b72.Td2a8ffLATEST_VERSION

Te6edf3providerTff7b72.Td2a8ffcloseTb4b4b4(Tb4b4b4)

Tff7b72def Td2a8fftest_database_health_snapshot_free_spaceTb4b4b4(Te6edf3temp_dbTb4b4b4)Tb4b4b4:

Te6edf3db Tff7b72= Te6edf3DatabaseTb4b4b4(Te6edf3temp_dbTb4b4b4)

Te6edf3dbTff7b72.Td2a8ffinitializeTb4b4b4(Tb4b4b4)

Te6edf3health Tff7b72= Te6edf3dbTff7b72.Td2a8ffget_database_health_snapshotTb4b4b4(Tb4b4b4)

Tff7b72assert Ta5d6ff"Ta5d6ffestimated_free_bytesTa5d6ff" Tff7b72in Te6edf3health

Tff7b72assert Te6edf3healthTb4b4b4[Ta5d6ff"Ta5d6ffestimated_free_bytesTa5d6ff"Tb4b4b4] Tff7b72>Tff7b72= T79c0ff0

Tff7b72assert Te6edf3healthTb4b4b4[Ta5d6ff"Ta5d6ffjournal_modeTa5d6ff"Tb4b4b4] Tff7b72== Ta5d6ff"Ta5d6ffwalTa5d6ff"

Tff7b72assert Te6edf3healthTb4b4b4[Ta5d6ff"Ta5d6fffreelist_pagesTa5d6ff"Tb4b4b4] Tff7b72== T79c0ff0

Tff7b72assert Te6edf3healthTb4b4b4[Ta5d6ff"Ta5d6ffestimated_free_bytesTa5d6ff"Tb4b4b4] Tff7b72> T79c0ff0